package com.one.group.admin.mapper;

import com.mybatisflex.core.BaseMapper;
import com.one.group.model.dto.SpBuildingAddDto;
import com.one.group.model.entity.SpHouse;
import com.one.group.model.vo.HouseManagementVo;
import com.one.group.model.vo.SpBillPayerVo;
import com.one.group.model.vo.SpHouseVo;

import java.util.List;

public interface SpHouseMapper extends BaseMapper<SpHouse> {
    List<HouseManagementVo> getHouseManagementList(Long buildingId,Long tenantId);

    List<String> getunitList(Long buildingId, Long tenantId);

    List<String> getfloorList(Long buildingId, Long tenantId);


    boolean removeByBuildingId(Long buildingId);

    List<Long> getUnitIdsByBuildingId(Long buildingId);

    List<Long> getFloorIdsByBuildingId(Long buildingId);

    int getHouseCountByUnitIdAndFloorId(Long unitId, Long floorId);

    Integer getHouseNumByBuildingIdAndHouseId(Long buildingId, Long houseId);

    SpBillPayerVo getSpBillPayerVo(Long houseId);

    Long getHouseIdByOwnerID(Long ownerId);

    SpHouseVo mySelectOneById(Long id);

}
